My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
-
Re: Using % Formula of Summary level
Hi @Buckeye1497, Try this formula: {quantity}/NULLIF(TO_NUMBER({item.custitem_containerquantity}),0) When using this field in a formula/computation, you need to convert the value to a number first si…1 -
Re: TOP CONTRIBUTOR FOR AUGUST 2022!
WOW! 31 Reactions, 15 Accepted Answers & 33 discussions participated in! Congratulations, @Gaurav_NS! 👏1 -
Re: Custom Total Amounts on Saved Search
Hi @Tybrneryan, Glad to have you with us today! Try these formula: Sum of Positives: CASE WHEN {amount} > 0 THEN {amount} END Sum of Negatives: CASE WHEN {amount} < 0 THEN {amount} END Hope thi…1 -
Re: Saved Search | Show Built Qty and Used in Build Qty in Work Orders
Hi @GLL, The sample I showed is just a simple search with the Criteria Type = Work Order. The Results fields are: Document Number Item * (This represents Main Line) Quantity Quantity Fulfilled/Receiv…1 -
Re: AE:MIN and MAX Date on Expected Receipt Dates
Hi @OliverK, Great to see you again and happy Friday to you as well! I think MIN/MAX function doesn't matter much in your formula since you have it set to "last order by". so it will o…1
